The Business Master (3rd Edition)/The Business Master (3rd Edition).iso/files/spreotus/spedcors/l9

Text File | 1992-06-06 | 5.1 KB | 199 lines

March 26, 19921L9

                      ╔════════════════╗
                      ║ THE READY MODE ║
                      ╚════════════════╝
  √√√   HIGHLIGHTING
        (Also Called Reverse Video)

        ▀  The cell that is in use on the spreadsheet will
           have a reverse color (video). It will stand out from
           the rest of the spreadsheet.
           This is called highlighting or reverse video.

          The cell that is highlighted will always have the flashing
          cursor-bar (called underscore bar). It is in this box
          that your next data will be stored. The flashing cursor is
          telling you that it is waiting for you to enter a command.


  √√√   THE READY MODE
        ▀  You must be in the Ready Mode to start entering data.
           The upper right corner of the worksheet has a small box
           that shows what mode you are in.
        ▀  If you are not in the "Ready Mode" press the Esc key
           once or twice.
        ▀ In the ready mode the screen is clear except for the
          empty worksheet.
        You must be in the Ready mode for the next lesson.

  √√√    HOW TO GET INTO THE READY MODE
        ▀  Press the Esc key several times. You will see the word
           "READY"  highlighted in the upper right-hand corner.
        ▀  Another method is to keep pressing the Enter key. It will
           reach the Ready mode.


  √√√  THE MATH SYMBOL HIERARCHY  (Who's first)
        Lotus uses many math functions like multiply, divide, add and
        subtract. To use these functions (called operators)
        correctly the computer must know the order of priority.
        When there is more than one math function in a formula
        the computer must decide which has the priority so that it
        will not be adding when it should be multiplying.

        An Operator is a symbol that represents  a mathematical function
        like multiply or add. These symbols are used with the cell
        addresses to create formulas: for example +A1-B1.

        The math symbols that you will be using are listed in the order
        that the computer will execute them.
        Exponentials (like 2 to the second Power.. 2x2 and written 2^)
        has the first priority. It is represented by the
        Caret symbol (^) from the top of key 6. The symbols are listed below:









                                - 4 -





        THE MATH SYMBOL HIERARCHY
      ▀ First       ^     Exponential
      ▀ Second      *     Multiplication
      ▀ Third       \     Division
      ▀ Fourth      +     Addition
      ▀ Fifth       -     Subtraction

        Some Examples:
        +A3+A4+A5+A6+A7...same as...
        @SUM(A3..A7)
        The formula @SUM(A3..A7) means add
        together all the numbers contained in
        cells A3, A4, A5, A6, AND A7.

      ▀ If you have this:  +A2-B3*2 you
        would multiply the B3 by 2, then subtract from A2.
      ▀ But if you isolate the A2-B3 by
        putting it in parenthesis like this:
        (A2-B3)*2, then you would first
        subtract B3 from A2, then multiply by 2.
        The parenthesis means do me first.

  √√√ MORE EXAMPLES
      ▀  34*C7,  Is 34 times the content of cell C7.
      ▀  345/D5    Is 345 divided by
         content of cell D5.
      ▀  +B3+C3    Is adding B3 to C3. A
        cell must have a plus or minus
        if it is the first item.

      ▀   -F6+H8     Subtract F6 from H8.
      ▀   3^2       Is 3 to the second power (3 X 3 =9).

  √√√  ENTERING AND EDITING DATA
        When you enter data into a cell 1-2-3 classifies each
        entry as one of two types: labels or values.
     ▀ Labels are text entries.
     ▀ Values are numbers and formula entries.

  √√√  LABELS
       A label is a text entry . It can include any combination
       of characters such as a name, address, numbers,
       and numeric symbols:
       for example:  Jane Thompson, 345 Hickory  St,
       33550, and  $5.07 can all be entered as labels.

  √√√  LABEL PREFIX
       Every label has a label prefix. They are used with
       labels for special effects. They control the label's
       position in a cell.

       The caret (^) centers the label in a cell.
       The backslash (\) repeats characters in
       the label to fill Cell.
       The Apostrophe is the default label prefix.
       If you don't enter it 1-2-3 does it for you.
       It aligns the label with left edge of a Cell.


                                - 5 -





  √√√  VALUES
       A value is an entry that begins with a number (0 to 9),
       or one of the numeric symbols.

        These symbols are called Values: + -  @ # $ . ( .
        The entry can be a number or a formula.
        You must precede the prefixes with an
        apostrophe (') to make it a Label.


                    *** END OF CHAPTER ***
                Press Esc key to return to Menu.

            Select "HOW TO START", then press <Enter> key.













































                                - 6 -